A revered soul and gospel singer and the mother of Whitney Houston, Cissy Houston’s life was celebrated nearly a week after her death at 91